object FmKanGelIrsaliye: TFmKanGelIrsaliye
  Tag = 239
  Left = 191
  Top = 104
  Width = 1027
  Height = 546
  Caption = 'Kanal Geli'#351'tirme '#304'rsaliye Olu'#351'tur'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  KeyPreview = True
  OldCreateOrder = False
  Position = poDefault
  Scaled = False
  Visible = True
  OnClose = FormClose
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Panel1: TPanel
    Left = 0
    Top = 487
    Width = 1019
    Height = 32
    Align = alBottom
    TabOrder = 3
    object bExcel: TButton
      Left = 6
      Top = 5
      Width = 73
      Height = 25
      Caption = 'Excelden Al'
      TabOrder = 0
      OnClick = bExcelClick
    end
    object PB: TProgressBar
      Left = 84
      Top = 8
      Width = 217
      Height = 17
      TabOrder = 1
      Visible = False
    end
    object pnlYetki: TPanel
      Tag = 1100
      Left = 466
      Top = 5
      Width = 30
      Height = 19
      BevelOuter = bvNone
      TabOrder = 2
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 0
    Width = 1019
    Height = 91
    Align = alTop
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 0
    DesignSize = (
      1019
      91)
    object Label3: TLabel
      Left = 540
      Top = 8
      Width = 33
      Height = 13
      Anchors = [akTop, akRight]
      Caption = 'Adres'
      Transparent = True
    end
    object Label1: TLabel
      Left = 4
      Top = 7
      Width = 110
      Height = 16
      Anchors = [akLeft]
      Caption = 'EXCEL IMPORT'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clRed
      Font.Height = -13
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object Label2: TLabel
      Left = 6
      Top = 38
      Width = 77
      Height = 13
      Caption = 'Kargo Firmas'#305
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object Label4: TLabel
      Left = 265
      Top = 24
      Width = 61
      Height = 13
      Caption = #304'rsaliye No'
      Visible = False
    end
    object Label5: TLabel
      Left = 265
      Top = 47
      Width = 55
      Height = 13
      Caption = 'Stokkodu'
      Visible = False
    end
    object Statusul: TLabel
      Left = 7
      Top = 61
      Width = 44
      Height = 13
      Caption = 'Stat'#252's'#252
      Transparent = True
    end
    object lblCarikodu: TLabel
      Left = 461
      Top = 27
      Width = 116
      Height = 13
      Caption = 'CariKodu('#246'rn:BOSH)'
      Visible = False
    end
    object wwDBRichEdit1: TwwDBRichEdit
      Left = 584
      Top = 1
      Width = 434
      Height = 89
      Align = alRight
      AutoURLDetect = False
      DataField = 'adres'
      DataSource = DSListe
      PrintJobName = 'Delphi 7'
      ReadOnly = True
      TabOrder = 5
      EditorCaption = 'Edit Rich Text'
      EditorPosition.Left = 0
      EditorPosition.Top = 0
      EditorPosition.Width = 0
      EditorPosition.Height = 0
      MeasurementUnits = muInches
      PrintMargins.Top = 1.000000000000000000
      PrintMargins.Bottom = 1.000000000000000000
      PrintMargins.Left = 1.000000000000000000
      PrintMargins.Right = 1.000000000000000000
      RichEditVersion = 2
      Data = {
        660000007B5C727466315C616E73695C64656666307B5C666F6E7474626C7B5C
        66305C666E696C204D532053616E732053657269663B7D7D0D0A5C766965776B
        696E64345C7563315C706172645C6C616E67313035355C625C66305C66733136
        5C7061720D0A7D0D0A00}
    end
    object edKargoTan: TwwDBLookupCombo
      Left = 91
      Top = 34
      Width = 153
      Height = 24
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'Ad'#9'20'#9'Ad'#9'T')
      LookupTable = adoKargoTan
      LookupField = 'ID'
      Navigator = False
      ParentFont = False
      TabOrder = 0
      AutoDropDown = False
      ShowButton = True
      AllowClearKey = False
    end
    object cbSonkullanici: TCheckBox
      Left = 266
      Top = 4
      Width = 102
      Height = 17
      TabStop = False
      Caption = 'Carisiz insert'
      TabOrder = 2
      OnClick = cbSonkullaniciClick
    end
    object irsno: TwwDBEdit
      Left = 327
      Top = 21
      Width = 121
      Height = 21
      TabOrder = 3
      UnboundDataType = wwDefault
      Visible = False
      WantReturns = False
      WordWrap = False
    end
    object Stokkodu: TwwDBEdit
      Left = 327
      Top = 44
      Width = 121
      Height = 21
      TabOrder = 4
      UnboundDataType = wwDefault
      Visible = False
      WantReturns = False
      WordWrap = False
      OnExit = StokkoduExit
    end
    object Statusuk: TwwDBComboBox
      Left = 91
      Top = 59
      Width = 154
      Height = 21
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        #304#351'lem Yap'#305'lmad'#305#9'1'
        'Devam Ediyor'#9'2'
        'Tamamland'#305#9'3')
      Sorted = False
      TabOrder = 1
      UnboundDataType = wwDefault
    end
    object cbSevkAdres: TCheckBox
      Left = 327
      Top = 67
      Width = 102
      Height = 17
      TabStop = False
      Caption = 'Sevk Adres'
      TabOrder = 6
      Visible = False
    end
    object edCarikodu: TwwDBEdit
      Left = 459
      Top = 43
      Width = 81
      Height = 21
      TabOrder = 7
      UnboundDataType = wwDefault
      Visible = False
      WantReturns = False
      WordWrap = False
    end
  end
  object cxGrid2: TcxGrid
    Tag = 239
    Left = 0
    Top = 172
    Width = 1019
    Height = 315
    Align = alClient
    PopupMenu = PMA
    TabOrder = 2
    LookAndFeel.NativeStyle = True
    object cxGridDB1TableView1: TcxGridDBTableView
      OnDblClick = cxgrid1DBTableView1DblClick
      OnKeyDown = cxgrid1DBTableView1KeyDown
      NavigatorButtons.ConfirmDelete = False
      DataController.DataSource = DSListe
      DataController.Filter.Active = True
      DataController.Filter.AutoDataSetFilter = True
      DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
      DataController.Summary.DefaultGroupSummaryItems = <
        item
          Format = 'Adet : ###.###'
          Kind = skCount
          FieldName = 'bilisno'
        end>
      DataController.Summary.FooterSummaryItems = <
        item
          Kind = skCount
          FieldName = 'carikodu'
          Column = cxgrid1DBTableView1carikodu
        end
        item
          Kind = skSum
          FieldName = 'SEC'
          Column = cxgrid1DBTableView1SEC
        end>
      DataController.Summary.SummaryGroups = <>
      FilterRow.InfoText = '  '
      FilterRow.Visible = True
      FilterRow.ApplyChanges = fracImmediately
      OptionsBehavior.IncSearch = True
      OptionsData.CancelOnExit = False
      OptionsData.Inserting = False
      OptionsSelection.CellSelect = False
      OptionsSelection.UnselectFocusedRecordOnExit = False
      OptionsView.Footer = True
      OptionsView.Indicator = True
      Styles.StyleSheet = dm.tvssDevExpress
      object cxgrid1DBTableView1SEC: TcxGridDBColumn
        Caption = 'Se'#231
        DataBinding.FieldName = 'SEC'
        PropertiesClassName = 'TcxCheckBoxProperties'
        Properties.ValueChecked = 1
        Properties.ValueUnchecked = 0
        Width = 27
      end
      object cxGridDB1TableView1AktarimNo: TcxGridDBColumn
        Caption = 'Akt.No'
        DataBinding.FieldName = 'AktarimNo'
        Width = 31
      end
      object cxGridDB1TableView1Tarih: TcxGridDBColumn
        Caption = 'Akt.Tarih'
        DataBinding.FieldName = 'Tarih'
        Width = 54
      end
      object cxgrid1DBTableView1carikodu: TcxGridDBColumn
        Caption = 'Cari Kodu'
        DataBinding.FieldName = 'carikodu'
        Width = 106
      end
      object cxgrid1DBTableView1firmaadi: TcxGridDBColumn
        Caption = 'Firma Ad'#305
        DataBinding.FieldName = 'firmaadi'
        SortIndex = 0
        SortOrder = soDescending
        Width = 186
      end
      object cxgrid1DBTableView1telefon1: TcxGridDBColumn
        Caption = 'Telefon 1'
        DataBinding.FieldName = 'telefon1'
        Width = 74
      end
      object cxGridDB1TableView1Telefon2: TcxGridDBColumn
        DataBinding.FieldName = 'Telefon2'
        Width = 47
      end
      object cxGridDB1TableView1Aciklama: TcxGridDBColumn
        Caption = 'A'#231#305'klama'
        DataBinding.FieldName = 'FaturaAciklama'
        Width = 197
      end
      object cxgrid1DBTableView1il: TcxGridDBColumn
        Caption = #304'l'
        DataBinding.FieldName = 'Il'
        Width = 58
      end
      object cxgrid1DBTableView1ilce: TcxGridDBColumn
        Caption = #304'l'#231'e'
        DataBinding.FieldName = 'Ilce'
        Width = 58
      end
      object cxGridDB1TableView1PostaKodu: TcxGridDBColumn
        DataBinding.FieldName = 'PostaKodu'
        Width = 35
      end
      object cxGridDB1TableView1unityirsaliyeno: TcxGridDBColumn
        Caption = #304'rsaliye No'
        DataBinding.FieldName = 'unityirsaliyeno'
        Width = 61
      end
      object cxGridDB1TableView1Yazdirma: TcxGridDBColumn
        Caption = 'Yazd'#305'rma'
        DataBinding.FieldName = 'Yazdirma'
        Width = 81
      end
      object cxGridDB1TableView1email: TcxGridDBColumn
        DataBinding.FieldName = 'email'
        Width = 84
      end
      object cxGridDB1TableView1fiptal: TcxGridDBColumn
        DataBinding.FieldName = 'iptal'
        Width = 43
      end
      object cxGridDB1TableView1irsaliyeTarih: TcxGridDBColumn
        Caption = #304'rsaliye Tarih'
        DataBinding.FieldName = 'irsaliyeTarih'
      end
      object cxGridDB1TableView1KargoTakipNo: TcxGridDBColumn
        Caption = 'Kargo Takip No'
        DataBinding.FieldName = 'KargoTakipNo'
        Width = 78
      end
      object cxGridDB1TableView1KargoFirma: TcxGridDBColumn
        Caption = 'Kargo Firma'
        DataBinding.FieldName = 'KargoFirma'
        Width = 104
      end
    end
    object cxGridLevel1: TcxGridLevel
      GridView = cxGridDB1TableView1
    end
  end
  object GroupBox1: TGroupBox
    Left = 0
    Top = 91
    Width = 1019
    Height = 81
    Align = alTop
    Caption = '  Listeleme K'#305'staslar'#305'  '
    TabOrder = 1
    object btListele: TButton
      Left = 969
      Top = 22
      Width = 63
      Height = 55
      Action = acListele
      TabOrder = 3
    end
    object rgirsaliyeDurum: TwwRadioGroup
      Left = 2
      Top = 15
      Width = 134
      Height = 64
      DisableThemes = False
      ItemIndex = 0
      Align = alLeft
      Caption = #304'rsaliye Durum'
      Items.Strings = (
        #304'rsaliye Olu'#351'turulmam'#305#351
        #304'rsaliye Olu'#351'turulmu'#351
        'T'#252'm'#252)
      TabOrder = 0
      Values.Strings = (
        '=0'
        '=1'
        '=IRS')
    end
    object rgYazdirmaDurum: TwwRadioGroup
      Left = 136
      Top = 15
      Width = 126
      Height = 64
      DisableThemes = False
      ItemIndex = 0
      Align = alLeft
      Caption = 'Yazd'#305'r'#305'lma Durum'
      Items.Strings = (
        #304'rsaliye Yazd'#305'r'#305'lmam'#305#351
        #304'rsaliye Yazd'#305'r'#305'lm'#305#351
        'T'#252'm'#252)
      TabOrder = 1
      Values.Strings = (
        '<>'#39'Y'#39
        '='#39'Y'#39
        '=isnull(f.iptal,'#39#39')')
    end
    object rgSecDurum: TwwRadioGroup
      Left = 262
      Top = 15
      Width = 110
      Height = 64
      DisableThemes = False
      ItemIndex = 0
      Align = alLeft
      Caption = 'Se'#231'me Durum'
      Items.Strings = (
        'Se'#231'ili Olmayanlar'
        'Se'#231'ili Olanlar'
        'T'#252'm'#252)
      TabOrder = 2
      Values.Strings = (
        '=0'
        '=1'
        '=SEC')
    end
    object GroupBox2: TGroupBox
      Left = 480
      Top = 15
      Width = 119
      Height = 64
      Align = alLeft
      Caption = #304'rsaliye Aral'#305#287#305
      TabOrder = 4
      object irsno1: TwwDBEdit
        Left = 7
        Top = 14
        Width = 106
        Height = 21
        TabOrder = 0
        UnboundDataType = wwDefault
        WantReturns = False
        WordWrap = False
      end
      object irsno2: TwwDBEdit
        Left = 7
        Top = 36
        Width = 106
        Height = 21
        TabOrder = 1
        UnboundDataType = wwDefault
        WantReturns = False
        WordWrap = False
      end
    end
    object GroupBox3: TGroupBox
      Left = 599
      Top = 15
      Width = 119
      Height = 64
      Align = alLeft
      Caption = 'Aktar'#305'm No Aral'#305#287#305
      TabOrder = 5
      object AktarimNo1: TwwDBSpinEdit
        Left = 7
        Top = 14
        Width = 106
        Height = 21
        Increment = 1.000000000000000000
        TabOrder = 0
        UnboundDataType = wwDefault
      end
      object AktarimNo2: TwwDBSpinEdit
        Left = 7
        Top = 36
        Width = 106
        Height = 21
        Increment = 1.000000000000000000
        TabOrder = 1
        UnboundDataType = wwDefault
      end
    end
    object GroupBox4: TGroupBox
      Left = 718
      Top = 15
      Width = 119
      Height = 64
      Align = alLeft
      Caption = 'Tarih Aral'#305#287#305
      TabOrder = 6
      object Tarih1: TwwDBDateTimePicker
        Left = 8
        Top = 14
        Width = 106
        Height = 21
        CalendarAttributes.Font.Charset = DEFAULT_CHARSET
        CalendarAttributes.Font.Color = clWindowText
        CalendarAttributes.Font.Height = -11
        CalendarAttributes.Font.Name = 'MS Sans Serif'
        CalendarAttributes.Font.Style = []
        Epoch = 1950
        ShowButton = True
        TabOrder = 0
      end
      object Tarih2: TwwDBDateTimePicker
        Left = 8
        Top = 36
        Width = 106
        Height = 21
        CalendarAttributes.Font.Charset = DEFAULT_CHARSET
        CalendarAttributes.Font.Color = clWindowText
        CalendarAttributes.Font.Height = -11
        CalendarAttributes.Font.Name = 'MS Sans Serif'
        CalendarAttributes.Font.Style = []
        Epoch = 1950
        ShowButton = True
        TabOrder = 1
      end
    end
    object GroupBox5: TGroupBox
      Left = 837
      Top = 15
      Width = 129
      Height = 64
      Align = alLeft
      Caption = 'Cari Kodu / Cari Ad'#305
      TabOrder = 7
      object Label6: TLabel
        Left = 1
        Top = 17
        Width = 14
        Height = 13
        Caption = 'CK'
      end
      object Label7: TLabel
        Left = 2
        Top = 40
        Width = 14
        Height = 13
        Caption = 'CA'
      end
      object CariKodu: TwwDBEdit
        Left = 16
        Top = 14
        Width = 106
        Height = 21
        TabOrder = 0
        UnboundDataType = wwDefault
        WantReturns = False
        WordWrap = False
      end
      object CariAdi: TwwDBEdit
        Left = 17
        Top = 36
        Width = 106
        Height = 21
        TabOrder = 1
        UnboundDataType = wwDefault
        WantReturns = False
        WordWrap = False
      end
    end
    object rgKargoTakip: TwwRadioGroup
      Left = 372
      Top = 15
      Width = 108
      Height = 64
      DisableThemes = False
      ItemIndex = 0
      Align = alLeft
      Caption = 'Se'#231'me Durum'
      Items.Strings = (
        'Kargo Tkp. Olm.'
        'Kargo Tkp. Ol.'
        'T'#252'm'#252)
      TabOrder = 8
      Values.Strings = (
        '='#39#39
        '<>'#39#39
        '=isnull(f.Har_Gonderino,'#39#39')')
    end
  end
  object adoListe: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select top 1  i.*,isnull(f.iptal,'#39#39#39#39') Yazdirma,f.Tarih irsaliye' +
        'Tarih,f.Har_Gonderino KargoTakipNo,(select AD from tbl_kargotani' +
        'm where Id=f.Kargo) KargoFirma from CS_KANAL_GELISTIRME_IRS i le' +
        'ft join fatura f on (i.BilisNo=f.Bilisno)')
    Left = 136
    Top = 320
  end
  object DSListe: TDataSource
    DataSet = adoListe
    Left = 136
    Top = 376
  end
  object PMA: TPopupMenu
    Left = 328
    Top = 378
    object Se1: TMenuItem
      Caption = 'Se'#231' / B'#305'rak'
      OnClick = Se1Click
    end
    object mnBrak1: TMenuItem
      Caption = 'T'#252'm'#252'n'#252' B'#305'rak'
      OnClick = mnBrak1Click
    end
    object mnSe1: TMenuItem
      Tag = 1
      Caption = 'T'#252'm'#252'n'#252' Se'#231
      OnClick = mnBrak1Click
    end
    object mnMiktarliSec: TMenuItem
      Caption = 'Miktarl'#305' Se'#231
      OnClick = mnMiktarliSecClick
    end
    object N1: TMenuItem
      Caption = '-'
    end
    object pma_Iptal: TMenuItem
      Caption = 'Se'#231'ili Olanlar'#305' Sil'
      OnClick = pma_IptalClick
    end
    object mnptalEt1: TMenuItem
      Tag = 1
      Caption = 'T'#252'm'#252'n'#252' Sil'
      OnClick = pma_IptalClick
    end
    object pma_Irsaliye: TMenuItem
      Caption = 'Se'#231'ili Olanlar'#305' '#304'rsaliyele'#351'tir'
      OnClick = pma_IrsaliyeClick
    end
    object pma_TopIrsaliye: TMenuItem
      Tag = 1
      Caption = 'T'#252'm'#252'n'#252' '#304'rsaliyele'#351'tir'
      OnClick = pma_IrsaliyeClick
    end
  end
  object oDlg: TOpenDialog
    Filter = 'Excel Dosyas'#305'|*.Xls'
    Left = 56
    Top = 536
  end
  object AdoTanim: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from  CS_TESLIMAT_TANIM')
    Left = 224
    Top = 320
  end
  object cnnnExcel: TADOConnection
    LoginPrompt = False
    Left = 224
    Top = 376
  end
  object adoExcelEO: TADOQuery
    Connection = cnnnExcel
    Parameters = <>
    SQL.Strings = (
      'select * from sheet1')
    Left = 320
    Top = 320
  end
  object AdoTemp: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select top 1  * from CS_KANAL_GELISTIRME_IRS')
    Left = 56
    Top = 320
  end
  object adoVbul: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select top 1  * from CS_KANAL_GELISTIRME_IRS')
    Left = 56
    Top = 376
  end
  object adoTemp2: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select top 1  * from CS_KANAL_GELISTIRME_IRS')
    Left = 136
    Top = 536
  end
  object adoTemp3: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select top 1  * from CS_KANAL_GELISTIRME_IRS')
    Left = 224
    Top = 536
  end
  object adoKargoTan: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from tbl_kargotanim where Aktif=1'
      '')
    Left = 324
    Top = 256
  end
  object ActionList1: TActionList
    Left = 488
    Top = 259
    object acListele: TAction
      Caption = 'Listele (F5)'
      ShortCut = 116
      OnExecute = acListeleExecute
    end
  end
end
